SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003520s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450052 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450052 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012579,826124,552733,905996,667208,731367,528278,157441,569525,449466,79100,100130,771328,237941,116014,849397,520532,934764,894579,607552,556116,525558,752584,68520,634733,300355,644638,441241,863867,303205,708310,893900,922367,318816,970416,1037510,267770,890424,307119,818592,845202,394502,76760,362743,400524,317531,462448,1015834,261263,525302,683230,1018236,495574,829425,851827,12176,603239,465925,25706,300350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450052 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450052 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]