SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54288 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54288 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630842,71107,500006,492666,451195,998537,802360,936856,579611,519072,398145,361279,182213,239276,533492,576517,339041,725782,471393,905705,94902,688713,360840,805324,759839,564670,719206,785721,156641,25904,283031,752821,430990,215110,895789,14686,907086,414993,946819,930244,483313,417794,367694,112972,424154,550574,157052,220901,564860,300063,835303,951345,20859,801593,618250,404807,569061,663010,682258,441996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]