SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310648 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310648 [ RunTime:0.005616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240826,767569,180190,791803,990635,1009454,244398,611832,161042,586365,648449,932862,790007,110330,230991,362466,381843,118733,142647,771161,537055,935037,193313,478908,620047,298002,366659,854217,565299,1044523,117649,15675,881642,39977,422581,414439,869144,291726,926338,547484,977586,329818,806405,1041999,515890,938974,337022,392024,378379,25639,708163,724919,641948,712943,3525,842374,847348,26307,679174,734143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]