SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001568s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985708 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985708 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014726,541766,713322,896554,116274,743246,6736,724674,855908,1030011,1033298,106469,415312,255000,672007,598607,422361,605572,78480,22176,693165,818229,539124,346635,436113,1045708,149691,352464,280299,728684,33470,174613,966409,269118,571308,405198,116652,337535,273864,337909,666878,830495,249685,228654,972209,927854,358164,510685,349254,445812,936148,97580,747904,541478,951931,52013,882135,461159,945556,161455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]