SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474617 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474617 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179235,148575,560713,703695,993663,584137,831650,518469,332844,66291,888670,149387,492896,270159,631146,1038177,598719,567180,940215,902907,567844,1010742,713819,517098,647458,507256,464359,261575,327258,298278,770359,192425,56232,928580,936236,169526,485026,1017531,1004191,15381,913963,101976,883765,742589,771320,441994,458028,604045,136760,896997,778020,174258,332501,512216,46218,904734,907926,703356,210538,312715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]