SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468319 LIMIT 1 [ RunTime:0.001192s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468319 [ RunTime:0.003847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699603,101659,664762,602718,824438,174797,1006470,498459,898713,393111,104565,542855,120346,114479,780885,773078,839426,191976,938914,281276,948299,299714,687314,329262,115682,800475,955204,3170,888156,874792,571855,584571,382547,573775,791259,820103,461472,619043,794847,976857,269217,404086,645455,1003799,433377,184061,562083,643291,127043,337766,739417,100563,50872,821042,472257,132678,792020,244221,181797,598196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]