SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342958 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342958 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664369,440121,58530,720918,846999,1010321,423069,952826,950695,851076,723864,993011,948236,260707,315073,1037818,1037717,554691,403073,1036510,704415,840284,275841,262448,595552,20252,480506,504440,222752,234344,932179,219747,43600,490065,940906,13218,853765,65455,610276,980878,270883,837605,209524,590613,181120,522545,323016,987556,231549,311,1015234,151019,568134,900772,746098,945501,678301,335729,557688,225608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]