SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56104 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56104 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265598,887996,124698,522010,475461,270465,14878,184599,630542,511583,18927,385738,287324,985600,330497,128412,484924,41516,516919,501097,699109,181162,505291,988690,771173,283917,211755,316221,153070,457939,222483,392676,176047,460205,343486,470670,536812,89451,685747,685548,1009875,1032543,564797,263480,535859,265329,323332,413315,185567,387083,210612,247709,839226,11847,828431,239394,657202,486626,416127,47596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]