SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472908 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472908 [ RunTime:0.002468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51240,229499,302060,188486,902800,642593,995932,78571,908326,78354,672196,317518,51702,235692,451039,25521,710333,896962,256403,890432,296915,392614,262016,129267,373710,328112,849770,131047,546786,134023,534295,727669,547456,128543,984683,564917,135865,758515,610422,857534,973080,608440,963236,534947,156999,311835,928181,107321,85438,417204,641604,699496,934841,882026,437182,665027,558525,124459,482676,145160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]