SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195474 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195474 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619335,823641,559903,315190,189764,671805,29442,238382,1042947,3721,182070,983094,774466,459024,107859,934503,627914,234150,471659,529564,121880,320567,180061,310224,178773,338249,226299,776971,1009094,352972,231433,12945,499942,994085,409790,864172,894191,730367,219109,752752,919444,313834,447060,599290,583640,124146,492882,42664,225269,187974,697692,865408,562656,864208,337539,477794,552500,960595,942338,707233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]