SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520346 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520346 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117125,936183,636109,801783,357084,987859,505762,569749,831743,87703,467301,496557,1013373,462494,758858,567311,398778,766634,91720,228533,701278,905330,426973,182444,324409,310390,530789,541471,223478,949894,173233,853684,15017,199360,125139,102392,487873,490162,239746,630642,510932,715175,788375,942021,287086,243384,130237,567954,702737,117100,992722,150949,999844,931863,284491,701069,937566,587798,626752,483675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]