SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036863 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036863 [ RunTime:0.001760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132837,41483,708331,246056,773634,707923,612744,419800,340818,475632,397775,94361,696531,97538,136353,846332,864060,604611,319913,145653,559341,691226,236903,761270,780162,640367,337900,355791,373671,99424,156388,120854,557644,39956,1012274,1043151,73085,93858,472242,224014,369863,576708,295662,915950,205744,642913,971274,410876,1024145,170428,481458,679134,611174,1011896,395686,130143,560122,251530,482185,158838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]