SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530925 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530925 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832777,512711,143437,974436,436846,571353,484135,824142,1008075,483756,904505,561947,337782,561779,679139,854372,710989,990204,1004932,368000,631916,491167,192913,41471,1043886,588746,948905,599491,846494,251486,449581,813212,722308,913074,13716,455207,442959,813145,496090,671285,833964,759871,82572,1000330,482436,1043164,923294,12582,93557,410290,709822,639037,962002,491582,837223,905933,60737,974734,265165,1043389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001514s ]