SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267741 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267741 [ RunTime:0.010110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412297,950437,515391,911463,823973,817038,853578,250917,389918,348105,643265,799268,261534,421066,482237,1001330,830283,700257,3324,723103,732492,25594,62243,471144,830412,827669,461685,347900,741666,157855,759628,111577,848724,7554,565268,526597,428884,403952,59858,795470,1024317,257470,213357,167978,538474,892333,553762,217437,1046186,607453,129033,1011899,418219,134818,371770,732340,545010,739258,588373,142988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]