SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502019 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502019 [ RunTime:0.010686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148758,859442,981643,938936,656280,175665,733922,1048393,568051,314609,356876,764913,694948,731581,394870,320032,364956,654675,218878,657413,471008,123112,264926,59064,101655,983930,481779,61032,795645,1029038,296254,1025840,880121,1010783,331927,458881,351689,897365,883527,556090,828789,210009,13787,478827,196682,697162,24010,421213,598896,730373,508421,707308,609449,606108,942467,525358,646680,1021370,825813,879197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]