SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569097 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569097 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288633,459753,778081,62009,255370,17296,1027446,447194,512367,502123,72612,412149,874211,844459,689121,366043,1042225,668149,787375,156936,840753,52428,383918,881206,938499,834903,746396,379847,737412,448605,219196,736228,193011,743512,886793,363053,858970,445767,548382,606225,117052,244504,129038,18640,482142,112389,460157,314651,863136,668374,469542,511249,139791,859963,415644,179104,681042,716741,796626,59844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]