SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502015 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502015 [ RunTime:0.004190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135981,1032997,322056,475183,695394,842262,15319,862230,945005,591618,290871,1043603,753120,843227,966998,572119,966976,61844,224380,129352,426552,187911,843748,960951,797226,978439,742638,962576,362188,881403,427604,8304,537626,767330,97039,535156,820748,17170,720588,495778,162574,69426,167015,537529,710924,27999,226351,969753,440274,912147,409250,80237,370685,352097,370119,867896,174893,916469,641260,180281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002750s ]