SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10711 LIMIT 1 [ RunTime:0.001482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10711 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523532,302260,445548,1041833,839277,590024,321977,940964,470336,247275,48244,300133,643788,714713,538535,715286,908947,768187,549673,27902,631952,927048,364363,216807,780026,21351,356855,3657,644371,35265,995157,713851,359370,217433,289662,493425,987034,41033,154409,480741,884931,438722,986187,455948,43652,497404,395794,361921,866761,777744,729408,987633,483232,690002,449468,201136,427281,788674,917574,332032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]