SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344905 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344905 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842729,487673,101055,180424,123558,830041,270691,481720,251318,992873,571544,460252,1006293,136852,1038079,608164,329454,587282,902007,155771,57647,453759,197747,71268,609386,466889,552612,210595,348766,465893,579249,297375,39266,498609,644100,397414,635713,183037,501857,20974,795710,998501,619456,370814,7121,485469,346380,439348,557757,814808,652908,35693,653584,849585,938514,868811,866264,907167,411370,299836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]