SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504024 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504024 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380683,915086,907847,1024692,251085,605486,423740,260065,955117,527944,402999,722941,361967,816483,644382,377515,226578,454179,918206,1026218,344735,280184,69141,1042402,502515,654566,529322,478485,113625,299398,638250,712395,227623,11030,136021,399627,1035018,754274,34916,950856,9693,790380,413997,330312,533633,347054,809133,22582,67167,587838,902897,167953,99523,923777,648170,300128,718003,666405,453765,370866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001864s ]