SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521716 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521716 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019875,13982,1036670,318217,678440,391229,92674,963873,175224,425340,370382,781636,48027,1045669,94658,780248,523824,255087,234083,488903,342360,1002867,1037159,81161,1024424,56108,756769,443866,160214,867467,294513,210696,955433,197530,856836,603107,845201,899545,175588,305107,249077,239156,590149,936709,908687,822918,688407,546127,128772,985635,1005469,600484,299520,61473,423990,1025793,967356,446974,130816,512033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]