SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904301 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904301 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150362,66189,50667,499088,311740,196489,297899,49395,187422,388274,1009178,475452,570799,466610,240319,1027454,871767,317040,311309,504637,1040008,321446,703362,270840,701998,731125,75595,728194,938446,498085,396021,863966,941331,94304,537890,937680,933036,640442,971792,743486,479824,883336,752256,798988,593871,567635,185770,962857,689394,312150,841480,486457,357030,881394,122821,883753,642553,410438,415326,351831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]