SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610823 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610823 [ RunTime:0.003075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326514,40835,121233,337125,271552,1022766,108572,714137,107991,562520,62366,581509,460284,962817,443015,110658,361951,1016774,26325,631020,1014214,383747,372732,361709,939332,440280,251586,806723,412132,1037819,705848,670029,322040,881770,731657,761176,996500,888152,447924,94049,123293,318100,114344,59149,42455,605349,779195,1012211,509190,323047,242567,373672,541175,151182,915378,50340,1033511,533524,965645,87822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000860s ]