SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534040 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534040 [ RunTime:0.004435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150855,134844,434757,707617,824464,73384,1021506,642380,933978,999374,270851,800569,516324,634320,673111,542532,268890,525183,125326,925220,1040027,380262,513546,879628,637182,240651,315737,892292,245559,731915,920421,608615,208921,891615,816113,930351,1002850,902134,134519,894324,1048508,1031899,20234,399477,354315,577101,1010158,886908,934642,819594,111284,587193,681069,889061,74071,575701,223418,560143,557709,154911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001868s ]