SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564713 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564713 [ RunTime:0.004545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900054,460787,1037673,555288,173321,895645,996305,685618,740173,606015,21074,155886,154513,423451,990825,894475,1025178,833071,779693,1025701,207950,986238,985231,928855,749500,539807,534205,45426,690934,662699,681331,944048,401653,210329,101777,486618,633623,900359,358148,662664,160557,659110,640153,80268,603121,778631,864008,751918,109110,119243,911729,776126,647076,1043569,612932,494723,765398,509515,508485,794701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001233s ]