SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841153 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841153 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595589,330678,294323,817007,916619,834157,93037,138334,981892,905650,1043072,661548,402031,816489,1043547,807852,575018,548345,834210,613637,506403,843511,712749,947700,985081,22085,480774,862791,1038901,139924,201150,830191,13767,548364,418677,261729,1002265,427780,755228,408004,774036,259578,133179,146045,290061,650264,669103,81183,145933,421719,118567,1017153,697695,43522,335188,501043,578720,704611,476809,781391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]