SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4398 LIMIT 1 [ RunTime:0.000649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4398 [ RunTime:0.003868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426100,685564,855613,841540,784261,438392,41288,151896,1003802,114971,319014,112732,969113,517344,591577,411350,42833,315225,641717,419556,802053,642578,325071,455955,104125,451256,184484,767957,811238,338080,584153,304601,368021,528590,765523,601414,57147,275277,632954,359964,200810,545201,415177,715248,28442,857805,598394,555138,863319,60615,163891,778316,671916,533043,269774,653824,184748,886244,696494,551951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002373s ]