SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043423 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043423 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333244,874654,171468,834638,491260,958981,758791,195248,583703,454614,146301,916866,629683,882749,258332,164588,867257,239445,130213,805331,352960,593661,175641,777100,114014,616746,579579,413747,222358,509573,480408,535426,654519,121219,1005692,353402,1033713,355045,439548,446977,868527,1045760,126361,440643,368274,421127,795386,145978,373974,357101,791238,519616,982979,981829,394442,263418,249173,205715,943910,575103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]