SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032014 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032014 [ RunTime:0.002951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149841,501194,276513,904713,975199,1039231,136357,553333,878899,904083,313971,644357,657727,407562,499398,821316,449457,822910,174572,204634,326113,217234,951895,969145,409851,243809,309678,169492,830793,950766,777365,841991,672202,73073,834169,14308,632865,697896,482741,736827,950015,863012,186938,189542,668539,93099,675944,236527,806182,371694,208518,572542,841295,616976,519154,740678,1038186,1024698,751431,556523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]