SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322858 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322858 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106523,519872,374633,748413,108164,184163,815913,353105,697658,213445,146562,515042,974436,252813,292566,158388,848069,253604,374772,20194,617947,9279,196055,618171,651229,883906,925105,85266,207184,983460,793619,988654,110637,868322,406541,382773,703342,263790,875943,760205,44373,187358,830849,952581,101134,438093,58312,893695,997174,126434,896693,138237,540798,1042461,964706,922345,517425,954378,82862,252564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322858 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322858 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002015s ]