SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546151 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546151 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140043,985012,1026733,144871,749533,310683,166410,698735,238699,769911,337294,1007492,611908,729205,909837,528384,692313,379580,446300,1022911,310873,414156,857118,139957,153148,145717,450986,1022487,770178,746702,265426,246232,952361,240599,139454,1016571,907352,93154,396859,47557,835655,85414,1045528,413892,198655,186313,886276,865795,1003843,997903,222198,639147,128484,585133,52648,771485,327872,233039,195269,720690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]