SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506963 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506963 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402230,604613,669035,195473,1009615,713845,70021,84976,699357,367183,844494,180302,941566,51791,80162,471513,495924,578749,223011,919419,393465,928830,673360,953760,892029,985961,336813,498683,92961,974829,163306,484199,1013811,315309,306371,548607,286527,271016,302045,502504,734898,461377,121060,1009817,809983,913457,744629,123860,43964,737801,301046,65488,362996,793452,944781,444981,657704,76056,380026,915838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]