SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408791 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408791 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274433,724282,791298,536465,393800,987622,542414,399228,1030899,686989,1019256,800977,867908,330688,452985,754302,810540,540935,120029,759744,64732,480186,14781,611230,902628,857999,204520,442711,26337,346420,338529,276790,783229,393978,166191,811381,341330,719121,848036,231659,308433,552421,696270,151207,876088,559498,486279,119433,194634,475473,263323,26383,457458,691494,889251,843751,248558,284680,536243,179549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]