SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 614303 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 614303 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147212,216612,627875,451285,168362,712972,422746,444247,101485,465282,277800,45122,92205,433723,131420,246149,207847,187150,86053,1035244,764679,653362,810633,888364,193440,316218,698847,106494,498802,634009,62144,1002154,315191,42290,606087,341459,59643,1003013,269397,63181,1033061,434328,314852,838889,548286,867640,633474,223870,405331,1025633,575919,914063,806487,165260,688104,1035182,580398,870818,701408,615382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 614303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 614303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]