SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504526 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504526 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332561,172539,887561,745071,558326,785117,267274,1043904,29238,779353,880968,45342,46279,577619,494824,529245,896288,113197,208148,128245,460527,832937,193798,714799,929625,1041574,847953,291216,849553,238453,29495,1018959,759368,13391,850728,798329,41211,947713,379631,571384,1027612,645569,883547,843323,954935,787111,188380,415107,431363,330742,260063,1038549,573110,357028,61043,946606,299649,983458,560522,160047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]