SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412380 LIMIT 1 [ RunTime:0.001272s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412380 [ RunTime:0.003590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697134,705219,751731,873380,571088,747723,231491,86473,775463,79222,69789,1035749,35483,273198,159704,843003,819885,1018204,1003736,493249,977380,7137,365039,322310,321404,741868,46094,890510,593230,811048,490938,864936,308639,18381,69363,922481,114945,934215,20445,435315,271615,447331,799086,315958,10541,600517,828805,1000780,78988,913810,536781,550647,419641,224245,48844,701481,665172,94837,461205,349792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]