SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269812 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269812 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438633,203978,894046,1033201,296464,44943,278759,507746,680887,489418,953984,593115,550735,160685,115137,240589,397307,305872,171118,659174,716498,248980,180606,899723,50086,782693,1024219,971620,637640,965789,61227,279437,288593,307378,813102,6723,689263,935785,1000881,427120,339774,746738,975683,503046,381575,574577,229855,342258,504723,751596,52429,231004,658599,422404,226668,801573,1037799,584225,139135,766218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]