SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023400 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023400 [ RunTime:0.002669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416766,10258,575553,1026975,109256,861619,917563,779185,854737,706316,101609,909230,262215,1018990,842456,384143,82118,405707,534960,911470,980098,45284,605792,674100,651997,848531,511887,883152,936140,48470,693306,1008243,684676,456067,422949,794225,842435,423447,138675,262301,1034408,134264,585085,13382,240911,467621,473966,609180,775747,369479,809183,13448,365744,88172,1037027,87541,539213,143222,891779,860210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]