SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529178 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529178 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334068,290712,554646,503607,172593,611673,1012438,156656,830665,1024566,63895,732131,866417,444024,783099,39389,114148,293597,36402,577344,391734,232466,150951,652841,490301,147295,467300,387968,41246,211985,863625,211580,654369,70738,127570,965787,603655,465339,1046177,81532,226779,601486,370780,272121,1041165,202092,170547,357009,357,768868,22631,495813,408827,593861,29667,310829,761978,159047,560582,216275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]