SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048716 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048716 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508287,948209,196170,450457,950281,256137,547395,33620,73003,54117,108103,242938,507628,231940,294219,293996,989406,802407,603012,475782,622135,490260,415908,155788,456053,1020054,1001466,501270,186065,915008,359495,164075,338954,960991,665006,8700,963809,33546,70144,168912,787819,100555,463622,155708,630951,692443,250142,731346,1031212,375863,333868,897758,776119,833167,908430,8511,540336,203845,975298,609222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]