SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414529 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414529 [ RunTime:0.005028s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994177,723503,607509,412515,164824,703646,408893,721984,753058,469182,411412,102015,582180,571869,918252,469010,362826,786020,168324,775434,513632,233674,275668,995655,138103,416084,994918,35982,369560,773059,823368,273289,700844,408412,899660,949535,881751,377133,881020,503569,788859,932874,887482,651904,176372,566081,386899,744908,285600,817718,846008,882675,24788,484422,984685,472036,1021716,835215,799925,889492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]