SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413412 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413412 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700755,1016671,114947,416000,163688,686779,583040,842986,928498,997018,442059,487889,418109,705503,592405,831925,447166,516457,661774,302663,69474,882780,1037733,997365,926267,1027002,846937,1013048,426946,694418,599615,1002929,167773,396022,278426,706914,230754,593098,965393,794435,632496,1000262,541205,647928,220960,738787,523829,515432,78473,256821,200601,258138,247140,693895,587907,974660,224188,275539,994028,277231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004812s ]