SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41699 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41699 [ RunTime:0.003294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261765,350411,977344,944437,577605,341785,1010059,725713,901195,214532,381490,293195,783398,17352,292354,525652,924543,147967,745496,323576,955845,417167,555552,162987,511624,504318,835996,210225,309406,654486,951222,335987,421235,225538,253412,836980,784696,934060,198496,1048013,180497,555330,190564,501872,585937,404403,32168,944141,50006,1041470,990597,993282,309847,766884,773059,382311,666468,685225,355855,623252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001172s ]