SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367048 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367048 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40257,539503,747310,693768,972390,773103,278736,1019952,682700,525031,197209,534454,198463,796521,470304,226782,789365,179676,351545,798076,268420,544727,111775,566911,773883,215176,861207,164071,646443,752343,3640,705054,628251,788794,506394,905137,634675,991953,209222,131755,809391,1013501,1024137,468896,945254,961908,972846,496581,498692,747319,891752,458188,1038279,521925,889466,474283,625310,949356,222315,317021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]