SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406521 LIMIT 1 [ RunTime:0.000684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406521 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425740,394045,823954,697374,435307,314481,898073,569757,531281,589623,289436,174620,470632,809296,72029,1045850,781232,603559,511503,15648,581549,6405,286046,201771,601174,567503,706943,624933,635011,960006,833529,683174,686063,328200,85979,157836,521768,821593,656528,511422,566481,442244,459591,1043233,839402,752963,953941,127110,594614,693676,135445,101935,660599,28,863137,905555,163612,756101,111820,25896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]