SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350004 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350004 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716927,152053,764962,675334,1006762,902404,461284,258349,271765,686086,291112,509717,162754,463312,663595,690705,631432,1023191,117403,386816,618834,271364,913672,324295,974496,484279,241581,358529,536134,324841,754278,869562,931435,48895,385113,228333,235415,1043935,133630,92972,1022392,389640,4847,933240,184184,966541,696169,745466,78014,571905,629424,307768,619247,617811,400877,486218,1039592,199473,290348,571485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]