SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107842 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107842 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657940,70354,70177,640044,545105,645138,472749,199846,18397,1029534,605785,11879,9015,756397,813435,494656,10045,624926,922935,664114,146042,194042,251163,11448,151528,1042771,995427,8314,508031,521477,180765,840539,769053,795330,148904,471894,1034897,976645,37261,214674,1017262,456277,1009519,1037340,200040,209880,335502,923821,170050,577983,856780,717359,797875,513628,316570,685476,796214,663799,743853,876047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]