SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402240 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402240 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996688,724283,940156,540456,66189,24185,837614,658976,678593,252678,276334,391473,313231,514,501650,628438,846722,293875,31312,554993,861750,349024,777920,337557,966986,517362,793594,844504,501355,671683,923417,247003,149750,18143,592863,70243,429679,341866,661364,592913,268094,603383,393722,15812,564587,386201,906445,645076,406122,578354,623877,398471,863133,128216,383648,102413,329410,231331,447737,979329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]