SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5613 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5613 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766789,387134,712970,785986,291407,716520,501836,13951,385938,902594,536769,338057,1001850,196470,835305,712623,986927,641375,443584,411564,35479,785476,231273,895668,874388,282075,822760,754574,273162,132023,540852,266996,360187,547169,759288,1011999,429158,404364,385972,747685,108684,1032059,1021160,46537,132978,883524,949251,140869,806366,151198,607124,694159,392358,137990,715835,770507,458629,383344,257642,853629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]