SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505535 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505535 [ RunTime:0.003850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605580,248637,69598,265464,611169,24777,839758,206702,413263,106898,721273,89349,677420,482207,856373,354243,397606,608914,36910,606270,306051,832415,485007,684546,455382,138730,254100,631122,703150,438890,118149,436514,695072,613297,59671,648814,334269,355949,304195,51315,78362,614195,490988,210135,205580,376350,189950,184930,158064,106763,806350,667513,177196,797781,716000,1046913,1014818,273841,566256,870373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000868s ]