SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045076 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045076 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171542,396285,317310,874911,498158,665180,358578,519320,336462,2955,913694,423326,306200,262110,648810,513939,927304,689179,36088,999827,939158,180230,112575,1010944,533069,706880,1016016,198818,976656,969284,649554,931671,6436,287259,912817,33954,746834,1000535,438898,59786,154778,535525,391285,3826,544266,807406,992035,97827,733538,819359,214593,985294,360523,266053,646071,798032,693315,904437,955438,30126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002267s ]