SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414770 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414770 [ RunTime:0.001369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315384,977438,556974,1020179,419965,61116,1034367,748588,18474,630527,708793,376832,586747,478810,653988,477109,67739,471849,840005,499186,645579,446636,997015,656534,686423,102375,408927,817079,917304,264550,836337,362659,172100,598856,89656,35937,723114,142912,635597,314714,696613,805319,798471,495540,172925,850048,256183,25560,597827,737481,210268,990770,903378,18043,196254,188166,791546,469182,897689,46403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]