SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406080 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406080 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695626,440055,896271,903849,825045,969971,579051,426895,589767,656264,787483,627739,672064,715657,767554,164808,865595,501309,764872,37724,261664,319240,868665,675582,334084,545533,862188,32196,643176,788047,669359,822242,204845,1041526,585249,1047564,525106,723433,713715,357838,686210,813043,487222,730238,170809,948398,1047550,605872,176271,827048,37700,812999,531455,431516,847297,160112,822335,72636,112939,791807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]