SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296923 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296923 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613441,362439,256138,273942,690977,502872,74519,177732,401103,341938,989449,599898,1014853,64161,884200,665443,414237,726439,90707,246718,116833,961531,23505,485664,338386,65586,163324,1011045,255253,148296,443900,12342,591989,606847,514167,1017177,280491,513938,421880,426547,188006,610990,21957,522909,139246,221403,446023,592561,140089,608890,910510,918486,150131,722851,384272,364548,277543,383925,691439,802735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]