SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110314 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110314 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211320,227285,393908,364247,188745,353886,83907,255654,260646,495740,108473,262866,209896,160649,167622,807306,1030483,747387,164926,428483,681008,770518,452565,462432,198933,675725,174597,306011,132938,378922,9314,797915,429278,74344,387971,125495,421592,937133,513074,191590,445560,876543,988198,878048,493971,123179,339552,1038937,390,244461,689625,706988,249922,207066,773623,745344,790570,185896,123662,761566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]