SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111824 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111824 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644363,1009760,20725,1000902,1000297,756773,489333,443141,906576,363251,346067,679744,427570,1007541,91717,895122,810820,941915,124379,1037613,352857,1003513,392651,1015109,175256,115419,1008688,454856,301749,529040,381884,748774,624060,588794,928965,236,215751,447124,455228,303995,557881,65269,637524,415464,734870,469746,790040,424486,678939,122504,948201,1021366,488586,968634,173118,981630,682350,822772,379993,294829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111824 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111824 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]