SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438527 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438527 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14335,92799,95079,753718,63288,601358,824267,669114,746620,40798,551743,489364,251652,151061,131262,864263,623669,535251,202212,942990,965578,1019086,912930,213683,412819,648962,410360,506618,511441,949869,495660,526551,593927,973513,744688,680946,722016,544405,975346,454175,171797,736958,575551,278333,749927,377218,239255,689757,308637,982877,897845,849734,616150,309071,102346,19539,647658,835175,79462,609965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]