SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037993 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037993 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427497,677260,604304,553090,421659,543200,309704,735854,251496,286134,248392,101638,652230,1001884,774857,984652,51972,647397,733793,622086,626357,323605,786740,120782,816245,1014506,69670,808465,116728,79342,947526,208303,594655,754723,950333,157321,920294,22594,718798,949831,296727,389051,87844,518795,112189,817476,739388,468513,571202,190637,429776,377824,933184,80902,1019716,501812,284453,1045227,74092,370836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001783s ]