SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412323 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412323 [ RunTime:0.003163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996802,419809,307952,694477,1006846,339625,771570,877012,438324,37981,746589,792690,390125,936003,54792,765299,592807,960467,1027476,504518,153421,754139,929677,317077,576649,227903,23631,750954,236766,549330,107131,1021953,467599,165641,1042337,210245,489325,828823,459457,390791,88580,275776,757015,763102,31377,688714,953498,365022,577455,214048,415101,326517,829059,748186,214494,411624,84803,413406,93162,739510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]