SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047618 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047618 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697730,765681,898983,323222,955873,288758,928540,1016808,527890,998485,101014,601897,294648,1025236,127330,408859,614636,934789,913025,244525,804312,163608,156488,109230,150646,631143,861132,1018205,72860,1000110,784476,1025334,157760,621284,350621,195266,811300,714168,861321,270340,115665,392571,811313,50686,75026,728602,739894,419406,540135,457542,530781,64208,732821,876891,731091,760516,625132,505539,886656,603859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001068s ]