SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543407 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543407 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748493,555354,948175,146029,761315,122069,810520,369496,1033239,380890,964519,1016920,946711,721196,206084,173030,1023766,311250,590920,490795,834778,423553,156660,199609,444446,156059,723137,955787,555622,966662,501392,490081,435321,795779,811436,959143,256503,582782,552428,1025546,90307,704416,633935,853796,607969,25555,362155,37765,958683,49048,163489,579391,717273,265720,113669,29102,1004691,352548,850539,718299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001402s ]