SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343618 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343618 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498287,261470,803788,936006,108998,723488,824428,230647,420887,853448,306915,532994,792129,958984,102683,108437,1014304,244153,292965,365646,196827,911132,764831,213487,130453,663816,758164,387806,535845,163063,819123,575856,717480,926837,174997,466828,498719,199742,1035137,426968,363255,277371,215127,228548,574844,142953,780585,804514,530563,380306,484961,104699,220279,894090,1016595,492281,251416,923244,493581,966242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]