SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104950 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104950 [ RunTime:0.001457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449163,390102,513642,950120,990291,763130,731142,426191,584989,225508,665103,515971,905778,329754,919201,232651,731025,599368,912181,464196,733071,534435,1034191,1028698,780010,60376,100054,41230,462496,328494,658241,593046,394007,797837,91273,677436,396895,702243,900286,284531,567698,286555,915003,137002,848962,1037578,381670,1002387,361513,3307,292659,871233,488921,344927,636104,428740,226119,451710,458692,52062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]