SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023995 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023995 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159989,172043,653420,986659,158828,716466,136785,361682,307869,440254,683828,644786,114398,518918,419184,418243,903151,631819,643383,452626,725773,233863,840707,606078,785066,985412,248507,874990,66167,645115,135651,1005726,610286,312387,410997,366899,439962,740087,548087,478161,721951,819150,496170,542087,287884,443316,797707,202969,50327,926944,906779,680744,500303,36688,408788,998860,206316,50277,373260,712931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]